SET NAMES utf8mb4
SELECT * FROM `i18n_cat`
SELECT * FROM `configs`
SELECT * FROM `countries` ORDER BY `ar_name`
SELECT * FROM `menu_cat` WHERE `status`=1 AND `sub_of`=21 ORDER BY `sort_id`
SELECT * FROM `menu_cat` WHERE `status`=1 AND `sub_of`=2 ORDER BY `sort_id`
SELECT * FROM `menu_cat` WHERE `status`=1 AND `sub_of`=3 ORDER BY `sort_id`
SELECT * FROM `menu_cat` WHERE `status`=1 AND `sub_of`=7 ORDER BY `sort_id`
SELECT * FROM `menu_cat` WHERE `status`=1 AND `sub_of`=15 ORDER BY `sort_id`
SELECT * FROM `menu_cat` WHERE `status`=1 AND `sub_of`=51 ORDER BY `sort_id`
SELECT * FROM `doctors_cat` WHERE `status`=1 AND `sub_of`=0 AND `in_footer`=1
SELECT * FROM `pages` WHERE `in_footer`=1
SELECT * FROM `menu_cat` WHERE `status`=1 AND `sub_of`=22 ORDER BY `sort_id`
SELECT `id` FROM `doctors_cat` WHERE `title` ='جراحة الأوعية الدموية' Limit 1
SELECT `id` FROM `doctors_cat` WHERE `sub_of` =7
SELECT d.*,c.`title` AS category FROM `doctors` d LEFT JOIN `doctors_cat` c ON c.`id`=d.`sub_of` WHERE d.`status` = 1 AND d.`sub_of` IN(7,89) LIMIT 0,9